/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : fish

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 30/06/2020 15:05:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT NULL COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT NULL COMMENT '参数键名',
  `config_value` varchar(255) DEFAULT NULL COMMENT '参数值',
  `config_type` char(1) DEFAULT NULL COMMENT '参数类型',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `ctime` datetime DEFAULT NULL COMMENT '创建时间',
  `utime` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, '菜单级数', 'system.menu.level', '5', NULL, '', '2020-06-13 14:49:27', '2020-06-13 14:49:32');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '组织ID',
  `dept_name` varchar(50) NOT NULL DEFAULT '' COMMENT '组织名称',
  `parent_id` int(20) NOT NULL DEFAULT '0' COMMENT '上级组织ID',
  `order_no` int(4) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `status` int(4) NOT NULL DEFAULT '0' COMMENT '部门状态 （0正常、1停用）',
  `ancestors` varchar(255) NOT NULL DEFAULT '' COMMENT '祖先',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `ctime` datetime(6) NOT NULL COMMENT '创建时间',
  `utime` datetime(6) NOT NULL ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, '大鱼科技', 0, 1, 0, '1,0', '', '2020-03-13 20:17:24.575000', '2020-06-26 21:44:01.456255');
INSERT INTO `sys_dept` VALUES (2, '人事行政', 1, 1, 0, '4,1,1,0', 'ssss', '2020-03-15 06:10:38.774000', '2020-06-26 21:44:01.456255');
INSERT INTO `sys_dept` VALUES (3, '技术部', 1, 2, 0, '4,1,1,0', '', '2020-03-15 06:10:52.176000', '2020-06-26 21:44:01.456255');
INSERT INTO `sys_dept` VALUES (10, '财务部', 1, 3, 0, '4,1,1,0', '', '2020-03-22 07:53:29.276000', '2020-06-26 21:44:01.456255');
INSERT INTO `sys_dept` VALUES (11, '市场部', 1, 4, 0, '1,0', '', '2020-03-22 07:56:35.030000', '2020-06-26 21:44:01.457670');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `job_name` varchar(255) NOT NULL DEFAULT '' COMMENT '岗位名称',
  `job_code` varchar(255) NOT NULL DEFAULT '' COMMENT '岗位编码',
  `order_no` int(4) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `status` int(4) NOT NULL DEFAULT '0' COMMENT '状态（0正常、1停用）',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '岗位描述',
  `ctime` datetime(6) NOT NULL COMMENT '创建时间',
  `utime` datetime(6) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (2, '总经理', 'CEO', 1, 0, '', '2020-03-16 19:47:06.056000', '2020-03-16 19:47:06.056000');
INSERT INTO `sys_job` VALUES (3, '工程师', 'IT', 2, 0, '', '2020-03-16 19:47:47.212000', '2020-03-20 17:45:00.548000');
INSERT INTO `sys_job` VALUES (4, '财务', 'FIANCE', 3, 0, '', '2020-03-20 17:45:58.828000', '2020-03-20 17:45:58.828000');
INSERT INTO `sys_job` VALUES (5, '运营', 'OPERATE', 4, 0, '', '2020-03-20 17:46:29.531000', '2020-06-26 19:06:16.012000');
COMMIT;

-- ----------------------------
-- Table structure for sys_job_res
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_res`;
CREATE TABLE `sys_job_res` (
  `job_id` int(20) NOT NULL,
  `role_id` int(20) NOT NULL,
  PRIMARY KEY (`job_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
  `login_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_id` int(20) DEFAULT NULL COMMENT '账号ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '登录账号',
  `login_ip` varchar(50) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `login_browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `login_os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `fail` tinyint(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `remark` varchar(255) DEFAULT '' COMMENT '提示消息',
  `ctime` datetime DEFAULT NULL COMMENT '访问时间',
  `utime` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`login_id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COMMENT='登录日志';

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `user_id` int(20) unsigned DEFAULT NULL COMMENT '账户ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `module` varchar(50) DEFAULT '' COMMENT '系统模块',
  `req_ip` varchar(50) DEFAULT '' COMMENT '主机地址',
  `req_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `req_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `req_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `req_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `handle_method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `fail` tinyint(1) DEFAULT NULL COMMENT '处理状态（0 正常、1 异常）',
  `result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `ctime` datetime DEFAULT NULL COMMENT '操作时间',
  `utime` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`oper_id`)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';

-- ----------------------------
-- Table structure for sys_res
-- ----------------------------
DROP TABLE IF EXISTS `sys_res`;
CREATE TABLE `sys_res` (
  `res_id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT '0' COMMENT '父资源ID',
  `res_name` varchar(255) NOT NULL DEFAULT '' COMMENT '资源名称',
  `res_path` varchar(255) NOT NULL DEFAULT '' COMMENT '资源路径',
  `res_type` char(1) NOT NULL DEFAULT '' COMMENT '资源类型（D目录 M菜单 B按钮）',
  `res_mark` varchar(255) NOT NULL DEFAULT '' COMMENT '资源标识',
  `order` int(4) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `target` varchar(20) NOT NULL DEFAULT '' COMMENT '打开方式（ALERT弹出  TAB页签）',
  `visible` tinyint(1) NOT NULL DEFAULT '0' COMMENT '资源状态（0显示 1隐藏）',
  `icon` varchar(100) DEFAULT '' COMMENT '资源图标',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `ctime` datetime(6) NOT NULL COMMENT '创建时间',
  `utime` datetime(6) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`res_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_res
-- ----------------------------
BEGIN;
INSERT INTO `sys_res` VALUES (1, 0, '系统管理', '#', 'D', '', 1, '', 0, 'fa fa-cogs', '系统管理', '2020-03-04 01:13:35.000000', '2020-06-26 19:00:33.942000');
INSERT INTO `sys_res` VALUES (2, 0, '系统监控', '#', 'D', '', 2, '', 0, 'layui-icon  layui-icon-search', '系统监控', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (3, 0, '系统工具', '#', 'D', '', 3, '', 0, 'layui-icon  layui-icon-util', '系统工具', '2020-03-04 01:13:35.000000', '2020-03-12 00:40:20.618000');
INSERT INTO `sys_res` VALUES (4, 1, '员工管理', '/system/user', 'M', 'system:user', 1, '', 0, 'layui-icon  layui-icon-user', '员工管理', '2020-03-04 01:13:35.000000', '2020-03-19 14:40:25.544000');
INSERT INTO `sys_res` VALUES (5, 1, '管理角色', '/system/role', 'M', 'system:user:role', 2, '', 0, 'layui-icon  layui-icon-templeate-1', '角色管理', '2020-03-04 01:13:35.000000', '2020-03-19 21:57:01.193000');
INSERT INTO `sys_res` VALUES (6, 1, '资源管理', '/system/res', 'M', 'system:user:role', 3, 'TAB', 0, 'layui-icon  layui-icon-list', '资源管理', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (8, 4, '添加员工', '/system/user/add', 'B', 'system:user:add', 1, '', 0, '111', '添加员工', '2020-03-04 01:13:35.000000', '2020-03-19 14:40:43.089000');
INSERT INTO `sys_res` VALUES (9, 4, '编辑员工', '/system/user/edit', 'B', 'system:user:edit', 1, '', 0, '', '编辑员工', '2020-03-04 01:13:35.000000', '2020-03-19 14:40:56.711000');
INSERT INTO `sys_res` VALUES (10, 4, '删除员工', '/system/user/del', 'B', 'system:user:del', 1, '', 0, '', '删除用户', '2020-03-04 01:13:35.000000', '2020-03-19 14:41:07.200000');
INSERT INTO `sys_res` VALUES (11, 4, '启停员工', '/system/user/status', 'B', 'system:user:status', 1, '', 0, '', '启停员工', '2020-03-04 01:13:35.000000', '2020-03-19 14:41:20.676000');
INSERT INTO `sys_res` VALUES (12, 4, '员工详情', '/system/user/info', 'B', 'system:user:info', 1, '', 0, '', '员工详情', '2020-03-04 01:13:35.000000', '2020-03-19 14:41:34.274000');
INSERT INTO `sys_res` VALUES (14, 5, '添加角色', '/system/role/add', 'B', 'system:role:add', 1, 'ALTER', 0, '', '添加角色', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (15, 5, '编辑角色', '/system/role/edit', 'B', 'system:role:edit', 1, 'ALTER', 0, '', '编辑角色', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (16, 5, '删除角色', '/system/role/del', 'B', 'system:role:del', 1, 'ALTER', 0, '', '删除角色', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (17, 5, '启停角色', '/system/role/status', 'B', 'system:role:status', 1, 'ALTER', 0, '', '启停角色', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (18, 5, '角色详情', '/system/role/info', 'B', 'system:role:info', 1, 'ALTER', 0, '', '角色详情', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (20, 6, '添加资源', '/system/res/add', 'B', 'system:res:add', 1, 'ALTER', 0, '', '添加资源', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (21, 6, '编辑资源', '/system/res/edit', 'B', 'system:res:edit', 1, 'ALTER', 0, '', '编辑资源', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (22, 6, '删除资源', '/system/res/del', 'B', 'system:res:del', 1, 'ALTER', 0, '', '删除资源', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (23, 6, '启停资源', '/system/res/status', 'B', 'system:res:status', 1, 'ALTER', 0, '', '启停资源', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (24, 6, '资源详情', '/system/res/info', 'B', 'system:res:info', 1, 'ALTER', 0, '', '资源详情', '2020-03-04 01:13:35.000000', '2020-03-04 01:13:40.000000');
INSERT INTO `sys_res` VALUES (26, 2, '数据监控', '/druid/index.html', 'M', 'system:druid', 1, 'TAB', 0, 'layui-icon  layui-icon-chart', '数据监控', '2020-03-04 01:13:35.000000', '2020-05-31 15:47:56.581000');
INSERT INTO `sys_res` VALUES (27, 3, '系统接口', '/swagger/swagger-ui.html', 'M', 'system:swagger', 1, '', 0, 'layui-icon  layui-icon-fonts-code', '系统接口', '2020-03-04 01:13:35.000000', '2020-05-31 16:50:39.797000');
INSERT INTO `sys_res` VALUES (29, 1, '组织架构', '/system/dept', 'M', 'system:dept', 4, '', 0, 'fa fa-connectdevelop', '组织架构', '2020-03-14 16:40:55.738000', '2020-03-18 18:36:42.546000');
INSERT INTO `sys_res` VALUES (30, 29, '添加部门', '/system/dept/add', 'B', 'system:dept:add', 1, 'TAB', 0, '11', '添加部门', '2020-03-14 18:06:29.600000', '2020-03-14 18:06:29.600000');
INSERT INTO `sys_res` VALUES (31, 29, '编辑部门', '/system/dept/edit', 'B', 'system:dept:edit', 2, 'TAB', 0, '2', '编辑部门', '2020-03-14 18:10:53.152000', '2020-03-14 18:10:53.152000');
INSERT INTO `sys_res` VALUES (32, 29, '删除部门', '/system/dept/del', 'B', 'system:dept:del', 3, 'TAB', 0, '3', '', '2020-03-14 18:13:26.373000', '2020-03-14 18:13:26.373000');
INSERT INTO `sys_res` VALUES (33, 29, '启停部门', '/system/dept/status', 'B', 'system:dept:status', 4, 'TAB', 0, '4', '', '2020-03-14 18:14:51.118000', '2020-03-15 04:43:30.638000');
INSERT INTO `sys_res` VALUES (34, 29, '部门详情', '/system/dept/info', 'B', 'system:dept:info', 5, 'TAB', 0, '5', '', '2020-03-14 18:16:01.936000', '2020-03-14 18:16:01.936000');
INSERT INTO `sys_res` VALUES (35, 1, '岗位管理', '/system/job', 'M', 'system:job', 5, 'TAB', 0, 'fa fa-briefcase', '', '2020-03-16 19:52:44.278000', '2020-03-16 19:59:27.663000');
INSERT INTO `sys_res` VALUES (37, 35, '添加岗位', '/system/job/add', 'B', 'system:job:add', 1, '', 0, '', '', '2020-03-16 19:54:21.943000', '2020-03-16 19:54:21.943000');
INSERT INTO `sys_res` VALUES (38, 35, '编辑岗位', '/system/job/edit', 'B', 'system:job:edit', 1, '', 0, '', '', '2020-03-16 19:55:11.940000', '2020-03-16 19:55:11.940000');
INSERT INTO `sys_res` VALUES (39, 35, '删除岗位', '/system/job/del', 'B', 'system:job:del', 1, '', 0, '', '', '2020-03-16 19:55:50.712000', '2020-03-16 19:55:50.712000');
INSERT INTO `sys_res` VALUES (41, 35, '岗位详情', '/system/job/info', 'B', 'system:job:info', 1, '', 0, '', '', '2020-03-16 19:57:08.018000', '2020-03-16 19:57:08.018000');
INSERT INTO `sys_res` VALUES (42, 4, '重置密码', '/system/user/password.json', 'B', 'system:user:password', 5, '', 0, '', '', '2020-05-31 16:54:30.777000', '2020-05-31 16:54:30.777000');
INSERT INTO `sys_res` VALUES (43, 46, '操作日志', '/system/operlog', 'M', 'system:operlog', 1, 'TAB', 0, 'fa fa-file-text-o', '', '2020-06-01 08:55:21.038000', '2020-06-02 12:07:45.983000');
INSERT INTO `sys_res` VALUES (44, 43, '日志详情', '/system/operlog/info', 'B', 'system:operlog:info', 1, '', 0, '', '', '2020-06-01 08:56:41.776000', '2020-06-13 15:59:19.191000');
INSERT INTO `sys_res` VALUES (46, 2, '日志管理', '#', 'D', '', 7, '', 0, 'fa fa-file-text-o', '', '2020-06-02 12:07:03.133000', '2020-06-24 20:17:19.843000');
INSERT INTO `sys_res` VALUES (47, 46, '登录日志', '/system/loginlog', 'M', 'system:loginlog', 2, 'TAB', 0, 'fa fa-sign-in', '', '2020-06-02 12:09:37.076000', '2020-06-02 12:09:37.076000');
INSERT INTO `sys_res` VALUES (48, 47, '日志详情', '/system/loginlog/info', 'B', 'system:loginlog:info', 1, '', 0, '', '', '2020-06-02 12:10:26.472000', '2020-06-02 12:10:26.472000');
INSERT INTO `sys_res` VALUES (49, 1, '系统参数', '/system/config', 'M', 'system:config', 6, '', 0, 'fa fa-sliders', '', '2020-06-13 14:41:58.766000', '2020-06-13 16:13:47.473000');
INSERT INTO `sys_res` VALUES (50, 49, '参数明细', '/system/config/info', 'B', 'system:config:info', 1, '', 0, '', '', '2020-06-13 14:43:29.297000', '2020-06-13 14:43:29.297000');
INSERT INTO `sys_res` VALUES (51, 49, '添加参数', '/system/config/add', 'B', 'system:config:add', 1, '', 0, '', '', '2020-06-13 14:44:09.177000', '2020-06-13 14:46:07.130000');
INSERT INTO `sys_res` VALUES (52, 49, '修改参数', '/system/config/edit', 'B', 'system:config:edit', 2, '', 0, '', '', '2020-06-13 14:44:59.234000', '2020-06-13 14:46:22.071000');
INSERT INTO `sys_res` VALUES (53, 49, '删除参数', '/system/config/del', 'B', 'system:config:del', 3, '', 0, '', '', '2020-06-13 14:45:33.281000', '2020-06-13 14:46:31.885000');
INSERT INTO `sys_res` VALUES (54, 3, '辅助工具', '/tools', 'M', 'tools', 1, '', 0, 'fa fa-suitcase', '', '2020-06-24 11:11:50.742000', '2020-06-24 11:16:18.623000');
INSERT INTO `sys_res` VALUES (55, 3, '文件上传', '/upload', 'M', 'upload', 3, 'TAB', 0, 'fa fa-upload', '', '2020-06-24 14:58:38.018000', '2020-06-24 14:58:38.018000');
INSERT INTO `sys_res` VALUES (56, 2, '系统任务', '/system/task', 'M', 'system:task', 3, 'TAB', 0, 'fa fa-tasks', '', '2020-06-25 18:28:22.398000', '2020-06-25 18:28:22.398000');
INSERT INTO `sys_res` VALUES (57, 56, '添加任务', '/system/task/add', 'B', 'system:task:add', 1, '', 0, '', '', '2020-06-25 18:29:11.696000', '2020-06-25 18:29:11.696000');
INSERT INTO `sys_res` VALUES (58, 56, '编辑任务', '/system/task/edit', 'B', 'system:task:edit', 2, '', 0, '', '', '2020-06-25 18:30:14.343000', '2020-06-25 18:30:14.343000');
INSERT INTO `sys_res` VALUES (59, 56, '查看详情', '/system/task/info', 'B', 'system:task:info', 4, '', 0, '', '', '2020-06-25 18:30:53.442000', '2020-06-26 10:11:46.264000');
INSERT INTO `sys_res` VALUES (60, 56, '调整任务状态', '/system/task/status', 'B', 'system:task:status', 5, '', 0, '', '', '2020-06-25 18:32:54.600000', '2020-06-25 18:32:54.600000');
INSERT INTO `sys_res` VALUES (61, 56, '删除任务', '/system/task/del', 'B', 'system:task:del', 6, '', 0, '', '', '2020-06-25 18:33:27.355000', '2020-06-25 18:33:27.355000');
INSERT INTO `sys_res` VALUES (62, 35, '启用|停用岗位', '/system/job/status', 'B', 'system:job:status', 1, '', 0, '', '', '2020-06-26 19:05:44.442000', '2020-06-26 19:05:44.442000');
INSERT INTO `sys_res` VALUES (63, 3, '响应码', '/system/code', 'M', 'system:code', 1, '', 0, 'fa fa-gg', '', '2020-06-29 18:34:10.951000', '2020-06-29 18:57:02.911000');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) NOT NULL COMMENT '角色名称',
  `role_key` varchar(20) NOT NULL DEFAULT '' COMMENT '角色标识',
  `sort` int(4) NOT NULL DEFAULT '0' COMMENT '排序',
  `status` int(4) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用 2删除）',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `ctime` datetime(6) NOT NULL COMMENT '创建时间',
  `utime` datetime(6) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `key_uniq` (`role_key`) USING BTREE COMMENT '唯一性'
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, 0, '超级管理员', '2020-03-04 00:55:40.000000', '2020-06-29 18:43:43.291000');
INSERT INTO `sys_role` VALUES (11, '系统测试员', 'test', 2, 0, '', '2020-06-08 22:36:24.619000', '2020-06-26 18:58:15.216000');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_res
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_res`;
CREATE TABLE `sys_role_res` (
  `role_id` int(20) NOT NULL,
  `res_id` int(20) NOT NULL,
  PRIMARY KEY (`role_id`,`res_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_role_res
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_res` VALUES (1, 1);
INSERT INTO `sys_role_res` VALUES (1, 2);
INSERT INTO `sys_role_res` VALUES (1, 3);
INSERT INTO `sys_role_res` VALUES (1, 4);
INSERT INTO `sys_role_res` VALUES (1, 5);
INSERT INTO `sys_role_res` VALUES (1, 6);
INSERT INTO `sys_role_res` VALUES (1, 8);
INSERT INTO `sys_role_res` VALUES (1, 9);
INSERT INTO `sys_role_res` VALUES (1, 10);
INSERT INTO `sys_role_res` VALUES (1, 11);
INSERT INTO `sys_role_res` VALUES (1, 12);
INSERT INTO `sys_role_res` VALUES (1, 14);
INSERT INTO `sys_role_res` VALUES (1, 15);
INSERT INTO `sys_role_res` VALUES (1, 16);
INSERT INTO `sys_role_res` VALUES (1, 17);
INSERT INTO `sys_role_res` VALUES (1, 18);
INSERT INTO `sys_role_res` VALUES (1, 20);
INSERT INTO `sys_role_res` VALUES (1, 21);
INSERT INTO `sys_role_res` VALUES (1, 22);
INSERT INTO `sys_role_res` VALUES (1, 23);
INSERT INTO `sys_role_res` VALUES (1, 24);
INSERT INTO `sys_role_res` VALUES (1, 26);
INSERT INTO `sys_role_res` VALUES (1, 27);
INSERT INTO `sys_role_res` VALUES (1, 29);
INSERT INTO `sys_role_res` VALUES (1, 30);
INSERT INTO `sys_role_res` VALUES (1, 31);
INSERT INTO `sys_role_res` VALUES (1, 32);
INSERT INTO `sys_role_res` VALUES (1, 33);
INSERT INTO `sys_role_res` VALUES (1, 34);
INSERT INTO `sys_role_res` VALUES (1, 35);
INSERT INTO `sys_role_res` VALUES (1, 37);
INSERT INTO `sys_role_res` VALUES (1, 38);
INSERT INTO `sys_role_res` VALUES (1, 39);
INSERT INTO `sys_role_res` VALUES (1, 41);
INSERT INTO `sys_role_res` VALUES (1, 42);
INSERT INTO `sys_role_res` VALUES (1, 43);
INSERT INTO `sys_role_res` VALUES (1, 44);
INSERT INTO `sys_role_res` VALUES (1, 46);
INSERT INTO `sys_role_res` VALUES (1, 47);
INSERT INTO `sys_role_res` VALUES (1, 48);
INSERT INTO `sys_role_res` VALUES (1, 49);
INSERT INTO `sys_role_res` VALUES (1, 50);
INSERT INTO `sys_role_res` VALUES (1, 51);
INSERT INTO `sys_role_res` VALUES (1, 52);
INSERT INTO `sys_role_res` VALUES (1, 53);
INSERT INTO `sys_role_res` VALUES (1, 54);
INSERT INTO `sys_role_res` VALUES (1, 55);
INSERT INTO `sys_role_res` VALUES (1, 56);
INSERT INTO `sys_role_res` VALUES (1, 57);
INSERT INTO `sys_role_res` VALUES (1, 58);
INSERT INTO `sys_role_res` VALUES (1, 59);
INSERT INTO `sys_role_res` VALUES (1, 60);
INSERT INTO `sys_role_res` VALUES (1, 61);
INSERT INTO `sys_role_res` VALUES (1, 62);
INSERT INTO `sys_role_res` VALUES (1, 63);
COMMIT;

-- ----------------------------
-- Table structure for sys_task
-- ----------------------------
DROP TABLE IF EXISTS `sys_task`;
CREATE TABLE `sys_task` (
  `task_id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `task_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
  `task_group` varchar(255) DEFAULT NULL COMMENT '任务分组',
  `task_class` varchar(255) DEFAULT NULL COMMENT '任务执行方法',
  `invoke_param` varchar(255) DEFAULT NULL COMMENT '调用参数',
  `task_cron` varchar(255) DEFAULT NULL COMMENT 'cron表达式',
  `time_zone` varchar(200) DEFAULT NULL COMMENT '时区',
  `status` int(4) DEFAULT NULL COMMENT '状态（0启动、1停止）',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `ctime` datetime(6) DEFAULT NULL COMMENT '创建时间',
  `utime` datetime(6) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_task
-- ----------------------------
BEGIN;
INSERT INTO `sys_task` VALUES (1, 'name', 'group', 'com.hardydou.system.tasks.Task', 'aaaa', '0/10 * * * * ?', NULL, 1, 'remark', '2020-06-25 18:50:17.135000', '2020-06-30 12:58:26.237000');
INSERT INTO `sys_task` VALUES (2, 'name1', 'group', 'com.hardydou.system.tasks.Task', 'bbbb', '0/10 * * * * ?', NULL, 0, 'aaa', '2020-06-30 12:38:46.435000', '2020-06-30 12:38:46.435000');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dept_id` int(20) NOT NULL DEFAULT '0' COMMENT '部门ID',
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(255) NOT NULL DEFAULT '' COMMENT '盐值',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '昵称',
  `sex` char(1) DEFAULT 'N' COMMENT '性别（F女 M男 N未知）',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机',
  `email` varchar(255) DEFAULT '' COMMENT '邮件',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `status` int(4) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用 2删除）',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `ctime` datetime(6) NOT NULL COMMENT '创建时间',
  `utime` datetime(6) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `USER_NAME_UNQ` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (5, 5, 'admin', '{bcrypt}$2a$10$PNkrkcoqIy5Mb7tXA3T7pO0DjWfDCzLohKFHeBjPbo4nxWYbOJJLu', '1', '管理员', 'F', '13232323232', '111@163.com', '/public/image/avatar/2020/176/55270591000000.png', 0, 'test', '2020-03-04 02:45:21.000000', '2020-03-04 02:45:25.000000');
INSERT INTO `sys_user` VALUES (44, 3, 'ceo001', '{bcrypt}$2a$10$YuOGL7CJeBJYSsNuPH7DTeiscbv3PJzGu8uH4aMiL7k.OaEpZGWsy', '', '张三', 'F', '13333333333', '133@11.com', '', 0, '', '2020-03-20 11:26:53.009000', '2020-03-20 11:26:53.009000');
INSERT INTO `sys_user` VALUES (53, 5, 'lisi', '{bcrypt}$2a$10$mrtslJJb4ziVOVYOVEy7EuYMtIgbIOJbYE4uF8U8FkAjGWWCN/Vne', '', '李四', 'M', '13400000000', '134@11.com', '', 0, '', '2020-03-20 17:43:32.935000', '2020-03-20 17:43:32.935000');
INSERT INTO `sys_user` VALUES (54, 11, '111111', '{bcrypt}$2a$10$ZGYqeHwuFgKN0L5mRc.0t.It5vKxAiCqa9BRkWHU8TLu071Uduvu.', '', '111111', 'F', '13211111111', '11@11.com', '', 1, 'fff', '2020-04-01 00:01:22.099000', '2020-04-01 00:01:22.099000');
INSERT INTO `sys_user` VALUES (55, 1, '222', '{bcrypt}$2a$10$bItxAGdu5xlVoWT3yISir.GJpPOppsGcqscm9JlJ7M4ezHr6kvL86', '', '222', 'M', '18211111111', '111@11.com', '', 0, 'aaafffffff', '2020-05-31 15:29:32.518000', '2020-05-31 15:29:32.518000');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_job`;
CREATE TABLE `sys_user_job` (
  `user_id` int(20) NOT NULL COMMENT '用户ID',
  `job_id` int(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_job` VALUES (55, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` int(20) NOT NULL,
  `role_id` int(20) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (5, 1);
INSERT INTO `sys_user_role` VALUES (55, 11);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
